\name{PRBOdbConnect}
\alias{PRBOdbConnect}
\title{Connect to PRBO databases}
\description{
Build database connections using RODBC or RMySQL for PRBO databases such as BMDE and PRBOdb
}
\usage{
PRBOdbConnect(driver="MySQL", group="PRBOdb", dbname="PRBOdb", ODBC=TRUE, ...) 
}
\arguments{
\item{driver}{the driver to use}
\item{group}{The MySQL group to use}
\item{dbname}{Name of the database to build connection to and query from}
\item{ODBC}{Boolean value denoting whether or not RODBC or RMySQL will be used for connection}
\item{\dots}{Additional variables that can get passed through to underlying functions}
}
\details{
    For most users, this function will not be used directly, but
    is instead needed within other Ravian functions.
    
    Access to the PRBOdb or BMDE databases requires
    authentication.  If you are using a PRBO computer, you most
    likely are configured properly.  However, other users will
    need to request the username and passwords required.  
    
    It is always good practice to close connections after they
    have been used.
}

\author{Mark Herzog \email{mherzog@prbo.org}}

\seealso{ \code{\link{PRBOdbConnect}}}

\examples{
# Connect to BMDE database and retrieve PointCount data from SamplingUnitID='1403' (a point within Codora point count station) using RMySQL library.
# Note: You must have your MySQL configured correctly to access databases within data.prbo.org
# Ask \email{mherzog@prbo.org} for more information
pcdata<-sqlQuery(db<-PRBOdbConnect(group="digir-ro"),"SELECT * FROM digir_extract where ROUTE_IDENT='RECR'")
}
\keyword{ connection }
\keyword{ database }
